package com.oracle.mapper;

import com.oracle.pojo.Member;
import com.oracle.pojo.MemberExample;
import java.util.List;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

public interface MemberMapper {
    int countByExample(MemberExample example);

    int deleteByExample(MemberExample example);

    int deleteByPrimaryKey(Integer id);

    int insert(Member record);

    int insertSelective(Member record);

    List<Member> selectByExample(MemberExample example);

    Member selectByPrimaryKey(Integer id);

    int updateByExampleSelective(@Param("record") Member record, @Param("example") MemberExample example);

    int updateByExample(@Param("record") Member record, @Param("example") MemberExample example);

    int updateByPrimaryKeySelective(Member record);

    int updateByPrimaryKey(Member record);

    @Select("select count(id) from member where loginname=#{loginname}")
    int selectByLoginNameCount(String loginname);

    @Select("select count(id) from member where email=#{email}")
    int selectByEmailCount(String email);

    @Select("select count(id) from member where phone=#{phone}")
    int selectByPhoneCount(String phone);
}